<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_users`;");
E_C("CREATE TABLE `ecs_users` (
  `user_id` mediumint(8) unsigned NOT NULL auto_increment,
  `aite_id` text NOT NULL,
  `email` varchar(60) NOT NULL default '',
  `user_name` varchar(60) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `question` varchar(255) NOT NULL default '',
  `answer` varchar(255) NOT NULL default '',
  `sex` tinyint(1) unsigned NOT NULL default '0',
  `birthday` date NOT NULL default '0000-00-00',
  `user_money` decimal(10,2) NOT NULL default '0.00',
  `frozen_money` decimal(10,2) NOT NULL default '0.00',
  `pay_points` int(10) unsigned NOT NULL default '0',
  `rank_points` int(10) unsigned NOT NULL default '0',
  `address_id` mediumint(8) unsigned NOT NULL default '0',
  `reg_time` int(10) unsigned NOT NULL default '0',
  `last_login` int(11) unsigned NOT NULL default '0',
  `last_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_ip` varchar(15) NOT NULL default '',
  `visit_count` smallint(5) unsigned NOT NULL default '0',
  `user_rank` tinyint(3) unsigned NOT NULL default '0',
  `is_special` tinyint(3) unsigned NOT NULL default '0',
  `ec_salt` varchar(10) default NULL,
  `salt` varchar(10) NOT NULL default '0',
  `parent_id` mediumint(9) NOT NULL default '0',
  `flag` tinyint(3) unsigned NOT NULL default '0',
  `alias` varchar(60) NOT NULL,
  `msn` varchar(60) NOT NULL,
  `qq` varchar(20) NOT NULL,
  `office_phone` varchar(20) NOT NULL,
  `home_phone` varchar(20) NOT NULL,
  `mobile_phone` varchar(20) NOT NULL,
  `is_validated` tinyint(3) unsigned NOT NULL default '0',
  `credit_line` decimal(10,2) unsigned NOT NULL,
  `passwd_question` varchar(50) default NULL,
  `passwd_answer` varchar(255) default NULL,
  `wxid` char(28) NOT NULL,
  `wxch_bd` char(2) NOT NULL,
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `email` (`email`),
  KEY `parent_id` (`parent_id`),
  KEY `flag` (`flag`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_users` values('1','','ecshop@ecshop.com','ecshop','4b714c69622111de3cb21e71c1890c83','','','0','1960-03-03','0.00','0.00','98388','15390','1','0','1421015584','0000-00-00 00:00:00','127.0.0.1','12','0','0','5256','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('2','','vip@ecshop.com','vip','232059cb5361a9336ccf1b8c2ba7657a','','','0','1949-01-01','0.00','0.00','0','0','0','0','0','0000-00-00 00:00:00','','0','0','0','','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('3','','text@ecshop.com','text','1cb251ec0d568de6a929b520c4aed8d1','','','0','1949-01-01','0.00','0.00','0','0','2','0','1242973574','0000-00-00 00:00:00','0.0.0.0','2','0','0','','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('5','','zuanshi@ecshop.com','zuanshi','815a71fb334412e7ba4595741c5a111d','','','0','1949-01-01','0.00','10000.00','0','0','0','0','0','0000-00-00 00:00:00','','0','3','0','','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('6','','497110669@qq.com','admin9041','c55704f595fdb443824d7a3791675a10','','','0','0000-00-00','0.00','0.00','2549','2549','3','1374721792','1390511268','0000-00-00 00:00:00','127.0.0.1','33','0','0','1586','0','0','0','','111@live.cn','4444','5555','666','777','0','0.00','favorite_movie','666','','');");
E_D("replace into `ecs_users` values('7','','admin1@qq.com','admin1','0192023a7bbd73250516f069df18b500','','','0','0000-00-00','0.00','0.00','0','0','0','1389925352','1389925352','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('8','','zhouhuan@ecmoban.com','admin2','0192023a7bbd73250516f069df18b500','','','0','0000-00-00','0.00','0.00','0','0','0','1389930278','1389930278','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','1','0.00','','','','');");
E_D("replace into `ecs_users` values('9','','1111@123.com','123456','6929f857f3080422fc161d08aec06229','','','0','0000-00-00','0.00','0.00','0','0','4','1390421161','1416349133','0000-00-00 00:00:00','127.0.0.1','17','0','0','659','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('10','','gt_getout123@qq.com','gt_getout123','cccf57b201784fcdbe9a8e1f0362cd39','','','0','0000-00-00','0.00','0.00','0','0','0','1419195963','1419196116','0000-00-00 00:00:00','127.0.0.1','2','0','0','3689','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('11','','ecmoban1@163.com','gt_yanxin','ea3db69c8a1181dc4409b5950ba650ed','','','0','1954-01-01','-2437.20','0.00','0','0','5','1419198127','1420762406','0000-00-00 00:00:00','127.0.0.1','47','0','0','4323','0','0','0','','','','','','','0','5000.00','','','','');");
E_D("replace into `ecs_users` values('14','','123456@qq.com','yx_cf_123','93d9eb34b91572d45a3ec94350923d7d','','','0','0000-00-00','0.00','0.00','0','0','0','1420767414','1420767414','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('13','','ecmoban2@163.com','gy_yx123','9999258ce822725f6213970ad93fcf45','','','0','0000-00-00','0.00','0.00','0','0','0','1420767298','1420767298','0000-00-00 00:00:00','127.0.0.1','1','0','0','','0','0','0','','','','','','','0','0.00','','','','');");
E_D("replace into `ecs_users` values('15','','782869779@qq.com','青蜂网络','d211ba0834e500da965e21dfc728a2d5','','','0','0000-00-00','588.00','0.00','397','397','6','1436657571','1446256809','0000-00-00 00:00:00','192.168.1.100','68','0','0','3382','0','0','0','','','','','','','0','0.00',NULL,NULL,'','');");
E_D("replace into `ecs_users` values('16','','7828697791@qq.com','小蜂2','dcc62e31c8030d9488969c5da73d2f16','','','0','0000-00-00','0.00','0.00','0','0','0','1445546426','1445546426','0000-00-00 00:00:00','127.0.0.1','1','0','0',NULL,'0','0','0','','','','','','','0','0.00',NULL,NULL,'','');");

require("../../inc/footer.php");
?>